Creating Test Cases

You can create multiple test cases at project level in Mapping Manager and record expected and actual results. These test cases can test data mappings and ETL process. You can also manage test cases as per your requirements.

To create test cases at project level, follow these steps:

  1. Go to Application Menu > Data Catalog > Mapping Manager > Workspace Mappings.
  2. Under the Workspace Mappings pane, expand the required project node.
  3. Click the Test Cases node.

    4. The Test Case Summary pane appears.

  4. Click .

    5. The Add New Test Case page appears.

  5. Enter appropriate values in the fields. Fields marked with a red asterisk are mandatory. Refer to the following table for field descriptions.

    6. Field Name

    Description

    Test Case Name

    Specifies the name of the test case.

    For example, Verifying the Completeness of Source Metadata.

    Test Case Label

    Specifies the unique label for the test case.

    For example, Source Metadata.

    Type of Testing

    Specifies the type of testing.

    For example, Metadata Testing.

    Test SQL Script

    Specifies the SQL script required in the test execution.

    For example, select * from dbo.ADS_ASSOCIATIONS.

    Description

    Specifies the test objective in brief.

    For example: The objective of the test case is to verify the completeness of source metadata.

    Expected Result

    Specifies the expected result of the test case in detail.

    For example: The source table should have 50 columns.

    Actual Result

    Specifies the actual test result after the execution of the test.

    For example: The source table has 39 columns.

    Testing Comments

    Specifies the testing comments about the test case.

    For example: The source metadata was scanned from a Sql Server database.
  6. Click Save and Exit.

    7. The test case is created and saved under the Test Cases node.

Once the test case is created, you can enrich it by:

Managing test cases involves:

  • Updating test cases
  • Exporting test cases
  • Deleting test cases